Cannot have aggregate function in ORDER BY clause <clause>. (Error 3097)

You cannot use an aggregate function in the ORDER BY clause of an SQL statement.